大神请赐教!excel中if函数怎么弄!如果小于等于100%,0,大于100%,300,大...答:如果小于100%,0,大于等于100%,300,大于等于120%,400,大于等于140%,500 =IF(A1<1,0,IF(A1<1.2,300,IF(A1<1.4,400,500)))或 =IF(A1>=1.4,500,IF(A1>=1.2,400,IF(A1>=1,300,0)))下拉填充
跪求excel2010 条件函数:X小于等于返回值为1;大于4小于等于8返回0.9+...答:X小于等于返回值为1;大于4小于等于8返回0.9+(1-(x-3)/5)); 大于等于9返回0.9 假设X是指A1单元格,则公式为 =IF(A1<=4,1,IF(A1<=8,0.9+1-(A1-3)/5,0.9))或 =IF(A1>8,0.9,IF(A1>4,0.9+1-(A1-3)/5,1))再或 =0.9+IF(A1>8,,IF(A1>4,1-(A1-3)/5,0....